/*
 Navicat Premium Data Transfer

 Source Server         : MYDB
 Source Server Type    : MySQL
 Source Server Version : 50725
 Source Host           : localhost:8889
 Source Schema         : mydb

 Target Server Type    : MySQL
 Target Server Version : 50725
 File Encoding         : 65001

 Date: 19/06/2019 14:25:07
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for T_Student
-- ----------------------------
DROP TABLE IF EXISTS `T_Student`;
CREATE TABLE `T_Student` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `stuno` int(12) NOT NULL,
  `stuname` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of T_Student
-- ----------------------------
BEGIN;
INSERT INTO `T_Student` VALUES (1, 201601, 'akashi');
INSERT INTO `T_Student` VALUES (2, 201602, 'asuka');
COMMIT;

-- ----------------------------
-- Table structure for article
-- ----------------------------
DROP TABLE IF EXISTS `article`;
CREATE TABLE `article` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `context` varchar(255) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of article
-- ----------------------------
BEGIN;
INSERT INTO `article` VALUES (1, '这里是文章标题', '这里是文章内容');
INSERT INTO `article` VALUES (3, '修改标题', '修改文字');
INSERT INTO `article` VALUES (5, '发布一篇文章', '这里是文章的内容');
COMMIT;

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `gender` tinyint(1) NOT NULL,
  `birth` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `class-info` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of student
-- ----------------------------
BEGIN;
INSERT INTO `student` VALUES (1, 'Michael Jackson', 1, '2019-04-23 21:35:29', '网工1班');
INSERT INTO `student` VALUES (2, 'Michael Jordan', 1, '2019-04-23 21:35:42', '网工2班');
INSERT INTO `student` VALUES (3, 'Taylor Swift', 0, '2019-04-23 21:35:33', '网工1班');
INSERT INTO `student` VALUES (4, 'Vivian Lee', 0, '2019-04-23 21:35:46', '网工2班');
INSERT INTO `student` VALUES (5, 'Jessica Simpson', 0, '2019-04-23 21:35:36', '网工1班');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
